LA City Expenditures by Month Since 2012

Original Dataset



In [1]:

    
import pandas as pd
import numpy as np



In [2]:

    
data = pd.read_csv("City_Expenditures_by_Month.csv")
data.head()









    Out[2]:






  
    
      
      FISCAL YEAR
      FISCAL MONTH NAME
      DEPARTMENT NAME
      ACCOUNT NAME
      EXPENDITURES
      FUND NAME
      ACCOUNT GROUP NAME
      ACCOUNT GROUP
      FISCAL MONTH NUMBER
      FISCAL PERIOD
      FUND
      DEPARTMENT
      ACCOUNT
    
  
  
    
      0
       2015
       APRIL
       AGING
           SALARIES GENERAL
       $236359.02
       GENERAL FUND (GENERAL BUDGET)
       SALARIES AND BENEFITS
       SAL
       10
       201510
       100
       2
       001010
    
    
      1
       2015
       APRIL
       AGING
         SALARIES AS NEEDED
        $13824.46
       GENERAL FUND (GENERAL BUDGET)
       SALARIES AND BENEFITS
       SAL
       10
       201510
       100
       2
       001070
    
    
      2
       2015
       APRIL
       AGING
                     TRAVEL
         $5441.68
       GENERAL FUND (GENERAL BUDGET)
                    EXPENSES
       EXP
       10
       201510
       100
       2
       002130
    
    
      3
       2015
       APRIL
       AGING
       CONTRACTUAL SERVICES
        $18670.61
       GENERAL FUND (GENERAL BUDGET)
                    EXPENSES
       EXP
       10
       201510
       100
       2
       003040
    
    
      4
       2015
       APRIL
       AGING
             TRANSPORTATION
          $250.00
       GENERAL FUND (GENERAL BUDGET)
                    EXPENSES
       EXP
       10
       201510
       100
       2
       003310



In [3]:

    
len(data)









    Out[3]:





70065



In [ ]:

	FISCAL YEAR	FISCAL MONTH NAME	DEPARTMENT NAME	ACCOUNT NAME	EXPENDITURES	FUND NAME	ACCOUNT GROUP NAME	ACCOUNT GROUP	FISCAL MONTH NUMBER	FISCAL PERIOD	FUND	DEPARTMENT	ACCOUNT
0	2015	APRIL	AGING	SALARIES GENERAL	$236359.02	GENERAL FUND (GENERAL BUDGET)	SALARIES AND BENEFITS	SAL	10	201510	100	2	001010
1	2015	APRIL	AGING	SALARIES AS NEEDED	$13824.46	GENERAL FUND (GENERAL BUDGET)	SALARIES AND BENEFITS	SAL	10	201510	100	2	001070
2	2015	APRIL	AGING	TRAVEL	$5441.68	GENERAL FUND (GENERAL BUDGET)	EXPENSES	EXP	10	201510	100	2	002130
3	2015	APRIL	AGING	CONTRACTUAL SERVICES	$18670.61	GENERAL FUND (GENERAL BUDGET)	EXPENSES	EXP	10	201510	100	2	003040
4	2015	APRIL	AGING	TRANSPORTATION	$250.00	GENERAL FUND (GENERAL BUDGET)	EXPENSES	EXP	10	201510	100	2	003310